


******************************Table A1*******************************************************************
******************************Table A1*******************************************************************
******************************Table A1*******************************************************************
cd "D:\Nanjing\2020\wage gap\Replication"   
use "labor-basic-tpu-reg-1.dta",clear

 gen indc_firm=1
gen cic2=floor(ind4_adj/100)

 bysort cic2: egen num_firm=sum(indc_firm)
 
duplicates drop cic2, force

merge 1:1 cic2 using  "cic2_firms.dta"

cap drop ratio
gen ratio= num_firm/num_firm_full
replace ratio=num_firm_full/ num_firm if cic2==25

gen name=""
replace name="Food Processing" if cic2==13
replace name="Food Manufacturing" if cic2==14
replace name="Beverage Manufacturing" if cic2==15
replace name="Tobacco Processing" if cic2==16
replace name="Textile" if cic2==17

replace name="Clothing and fiber products" if cic2==18
replace name="Leather Products" if cic2==19
replace name="Wood and banboo products" if cic2==20
replace name="Furniture products" if cic2==21
replace name="Paper and paper pulp" if cic2==22

replace name="Printing, tap, and film products" if cic2==23
replace name="Educational and sport product" if cic2==24
replace name="Petroleum and coking industry" if cic2==25
replace name="Chemical materials" if cic2==26
replace name="Medical products" if cic2==27
replace name="Chemical fiber" if cic2==28

replace name="Rubber products" if cic2==29
replace name="Plastic products" if cic2==30
replace name="Nonmetalic mineral" if cic2==31
replace name="Ferrous metal smelt" if cic2==32
replace name="Non-ferrous metal smelt" if cic2==33
replace name="Metalic products" if cic2==34

replace name="General machinery" if cic2==35
replace name="Special equipment" if cic2==36
replace name="Transportation equipment" if cic2==37
replace name="Communication equipment" if cic2==39
replace name="Electric Components" if cic2==42

keep if name!=""
sort cic2
list name ratio
 
 